package com.locatme.modelBD;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class BdLocatme extends SQLiteOpenHelper {

    //nom et version de la base de donnÃ©e
    private static final String NOM_BDD = "locatme.sqlite";
    private static final int VERSION_BDD = 28;

    //=========================================Table TypeEtablissement=====================================//
    public static final String TABLE_TYPE_ETAB="TypeEtablissement";
    public static final String COL_ID_TYPE= "id_type";
    public static final String COL_TYPE = "type";

    //Creation table TypeEtab
    private static final String CREATE_TABLE_TYPE_ETAB = "CREATE TABLE IF NOT EXISTS "+ TABLE_TYPE_ETAB +
            "("+COL_ID_TYPE+" INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_TYPE +" TEXT NOT NULL);";

    //Suppression table TypeEtab
    private static final String DROP_TABLE_TYPE_ETAB = "DROP TABLE IF EXISTS "+TABLE_TYPE_ETAB+";";

    //=======================================Table Localisation================================//
    public static final String TABLE_LOCALISATION="Localisation";
    public static final String COL_ID_LOC= "id_loc";
    public static final String COL_LATITUDE = "latitude";
    public static final String COL_LONGITUDE = "longitude";

    //Creation table Localisation
    private static final String CREATE_TABLE_LOCALISATION = "CREATE TABLE IF NOT EXISTS "+ TABLE_LOCALISATION +
            "("+COL_ID_LOC+" INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_LATITUDE +" NUMERIC ,"+COL_LONGITUDE +" NUMERIC);";

    //Suppression table Localisation
    private static final String DROP_TABLE_LOCALISATION = "DROP TABLE IF EXISTS "+TABLE_LOCALISATION+";";

    //============================================Table Note=============================================//
    public static final String TABLE_NOTE="Note";
    public static final String COL_ID_NOTE= "id_note";
    public static final String COL_NOTE = "note";

    //Creation table Note
    private static final String CREATE_TABLE_NOTE = "CREATE TABLE IF NOT EXISTS "+ TABLE_NOTE +
            "("+COL_ID_NOTE+" INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_NOTE +" FLOAT NOT NULL);";

    //Suppression table Note
    private static final String DROP_TABLE_NOTE = "DROP TABLE IF EXISTS "+TABLE_NOTE+";";

    //==============================================Table Enseigne===============================//
    public static final String TABLE_ENSEIGNE="Enseigne";
    public static final String COL_LOGIN_ENSEIGNE = "login_enseigne";
    public static final String COL_PWD_Enseigne = "pwd_enseigne";
    public static final String COL_ID_NOTE_E = "id_note";
    public static final String COL_NOM_ENSEIGNE="nom_enseigne";
    public static final String COL_DESC_ENSEIGNE="desc_enseigne";
    public static final String COL_ID_TYPE_ENSEIGNE="id_type";
    public static final String COL_H_OUVERTURE="heure_ouverture";
    public static final String COL_H_FERMETURE="heure_fermeture";
    public static final String COL_ID_LOC_E="id_loc";

    //Creation table Enseigne
    private static final String CREATE_TABLE_ENSEIGNE = "CREATE TABLE IF NOT EXISTS "+ TABLE_ENSEIGNE +
            "("+COL_LOGIN_ENSEIGNE +" TEXT PRIMARY KEY NOT NULL,"+ COL_PWD_Enseigne +" TEXT NOT NULL," +
            COL_DESC_ENSEIGNE +" TEXT," +COL_ID_TYPE_ENSEIGNE +" INTEGER," +COL_NOM_ENSEIGNE+" TEXT," +
            COL_ID_NOTE_E +" INTEGER," + COL_H_OUVERTURE +" TEXT ,"+COL_H_FERMETURE+" TEXT," +COL_ID_LOC_E+" INTEGER," +
            "FOREIGN KEY ("+COL_ID_TYPE_ENSEIGNE+") REFERENCES "+TABLE_TYPE_ETAB+"("+COL_ID_TYPE+")"+
            "FOREIGN KEY ("+COL_ID_LOC_E+") REFERENCES "+TABLE_LOCALISATION+"("+COL_ID_LOC+")," +
            "FOREIGN KEY ("+COL_ID_NOTE_E+") REFERENCES "+TABLE_NOTE+"("+COL_ID_NOTE+"));";

    //Suppression table Enseigne
    private static final String DROP_TABLE_ENSEIGNE = "DROP TABLE IF EXISTS "+TABLE_ENSEIGNE+";";

    //============================================Table Personne===============================//
    public static final String TABLE_PERSONNE="Personne";
    public static final String COL_LOGIN_PERSONNE= "login_personne";
    public static final String COL_PWD_PERSONNE = "pwd_personne";
    public static final String COL_NOM_P="nom_p";
    public static final String COL_PRENOM_P="prenom_p";
    public static final String COL_PSEUDO="pseudo";
    public static final String COL_ID_NOTE_P = "id_note";
    public static final String COL_ID_LOC_P="id_loc";

    //Creation table Personne
    private static final String CREATE_TABLE_PERSONNE = "CREATE TABLE IF NOT EXISTS "+ TABLE_PERSONNE +
            "("+COL_LOGIN_PERSONNE+" TEXT PRIMARY KEY NOT NULL," +  COL_PWD_PERSONNE +" TEXT NOT NULL," +
            COL_NOM_P +" TEXT," + COL_PRENOM_P +" TEXT," + COL_ID_NOTE_P +" INTEGER," +COL_ID_LOC_P+" INTEGER," +
            COL_PSEUDO +" TEXT," +
            "FOREIGN KEY ("+COL_ID_LOC_P+") REFERENCES "+TABLE_LOCALISATION+"("+COL_ID_LOC+")," +
            "FOREIGN KEY ("+COL_ID_NOTE_P+") REFERENCES "+TABLE_NOTE+"("+COL_ID_NOTE+"));";

    //Suppression table Personne
    private static final String DROP_TABLE_PERSONNE = "DROP TABLE IF EXISTS "+TABLE_PERSONNE+";";

    //============================================Table Langue================================//
    public static final String TABLE_LANGUE="Langue";
    public static final String COL_ID_LANGUE= "id_langue";
    public static final String COL_NOM_LANGUE = "nom_langue";

    //Creation table Langue
    private static final String CREATE_TABLE_LANGUE = "CREATE TABLE IF NOT EXISTS "+ TABLE_LANGUE +
            "("+COL_ID_LANGUE+" INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_NOM_LANGUE +" TEXT NOT NULL);";

    //Suppression table Langue
    private static final String DROP_TABLE_LANGUE = "DROP TABLE IF EXISTS "+TABLE_LANGUE+";";


    //========================================Table Commentaire================================//
    public static final String TABLE_COMMENTAIRE="Commentaire";
    public static final String COL_ID_COMMENTAIRE= "id_commentaire";
    public static final String COL_COMMENTAIRE = "commentaire";
    public static final String COL_LOGIN_P = "login_personne";
    public static final String COL_LOGIN_E = "login_enseigne";

    //Creation table Commentaire
    private static final String CREATE_TABLE_COMMENTAIRE = "CREATE TABLE IF NOT EXISTS "+ TABLE_COMMENTAIRE +
            "("+COL_ID_COMMENTAIRE+" INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_COMMENTAIRE +" TEXT NOT NULL,"+COL_LOGIN_P +" TEXT NOT NULL," + COL_LOGIN_E +" TEXT NOT NULL," +
            "FOREIGN KEY ("+COL_LOGIN_P+") REFERENCES "+TABLE_PERSONNE+"("+COL_LOGIN_PERSONNE+")" +
            "FOREIGN KEY ("+COL_LOGIN_E+") REFERENCES "+TABLE_ENSEIGNE+"("+COL_LOGIN_ENSEIGNE+"));";

    //Suppression table Commentaire
    private static final String DROP_TABLE_COMMENTAIRE = "DROP TABLE IF EXISTS "+TABLE_COMMENTAIRE+";";


    //=======================================Table Message=====================================//
    public static final String TABLE_MESSAGE="Message";
    public static final String COL_ID_MESSAGE= "id_message";
    public static final String COL_OBJET_MESSAGE= "objet_message";
    public static final String COL_MESSAGE = "txtmessage";
    public static final String COL_DATE_MESSAGE = "date_message";
    public static final String COL_LOGIN_EMETTEUR = "login_emet";
    public static final String COL_LOGIN_RECEPTEUR = "login_recept";
    //Creation table Message
    private static final String CREATE_TABLE_MESSAGE = "CREATE TABLE IF NOT EXISTS "+ TABLE_MESSAGE +
            "("+COL_ID_MESSAGE+" INTEGER PRIMARY KEY AUTOINCREMENT," + COL_OBJET_MESSAGE +" TEXT,"+
            COL_MESSAGE +" TEXT NOT NULL,"+COL_DATE_MESSAGE +" TEXT,"
            +COL_LOGIN_EMETTEUR +" TEXT NOT NULL,"+COL_LOGIN_RECEPTEUR +" TEXT NOT NULL);";

    //Suppression table Message
    private static final String DROP_TABLE_MESSAGE = "DROP TABLE IF EXISTS "+TABLE_MESSAGE+";";


    //===============================Table association entre personne et langue============================//
    public static final String TABLE_LANGUE_PERSONNE="LanguePersonne";
    public static final String COL_LOGIN_PERSONNE_LP="login_personne";
    public static final String COL_ID_LANGUE_LU="id_langue";

    //Creation table associative
    private static final String CREATE_TABLE_LANGUE_PERSONNE = "CREATE TABLE IF NOT EXISTS "+ TABLE_LANGUE_PERSONNE +
            "("+COL_LOGIN_PERSONNE_LP+" TEXT NOT NULL," +
            COL_ID_LANGUE_LU +" INTEGER NOT NULL," +
            "FOREIGN KEY ("+COL_LOGIN_PERSONNE_LP+") REFERENCES "+TABLE_PERSONNE+"("+COL_LOGIN_PERSONNE+")," +
            "FOREIGN KEY ("+COL_ID_LANGUE_LU+") REFERENCES "+TABLE_LANGUE+"("+COL_ID_LANGUE+"));";

    //Suppression table associative
    private static final String DROP_TABLE_LANGUE_PERSONNE = "DROP TABLE IF EXISTS "+TABLE_LANGUE_PERSONNE+";";

    //===============================Table association entre enseigne et langue============================//

    public static final String TABLE_LANGUE_ENSEIGNE="LangueEnseigne";
    public static final String COL_LOGIN_ENSEIGNE_LE="login_enseigne";
    public static final String COL_ID_LANGUE_LE="id_langue";

    //Creation table associative
    private static final String CREATE_TABLE_LANGUE_ENSEIGNE = "CREATE TABLE IF NOT EXISTS "+ TABLE_LANGUE_ENSEIGNE +
            "("+COL_LOGIN_ENSEIGNE_LE+" TEXT NOT NULL," +
            COL_ID_LANGUE_LE +" INTEGER NOT NULL," +
            "FOREIGN KEY ("+COL_LOGIN_ENSEIGNE_LE+") REFERENCES "+TABLE_ENSEIGNE+"("+COL_LOGIN_ENSEIGNE+")," +
            "FOREIGN KEY ("+COL_ID_LANGUE_LE+") REFERENCES "+TABLE_LANGUE+"("+COL_ID_LANGUE+"));";

    //Suppression table associative
    private static final String DROP_TABLE_LANGUE_ENSEIGNE = "DROP TABLE IF EXISTS "+TABLE_LANGUE_ENSEIGNE+";";

    //===============================Table association Favoris personne=================================//
    public static final String TABLE_FAVORIS_P="FavorisP";
    public static final String COL_LOGIN_PERSONNE_F="login_personne";
    public static final String COL_LOGIN_FAVORIS_F="login_favoris_p";

    //Creation table association
    private static final String CREATE_TABLE_FAVORIS_P = "CREATE TABLE IF NOT EXISTS "+ TABLE_FAVORIS_P+
            "("+COL_LOGIN_PERSONNE_F+" TEXT NOT NULL," +
            COL_LOGIN_FAVORIS_F +" TEXT NOT NULL," +
            "FOREIGN KEY ("+COL_LOGIN_PERSONNE_F+") REFERENCES "+TABLE_PERSONNE+"("+COL_LOGIN_PERSONNE+")," +
            "FOREIGN KEY ("+COL_LOGIN_FAVORIS_F+") REFERENCES "+TABLE_PERSONNE+"("+COL_LOGIN_PERSONNE+"));";

    //Suppression table association
    private static final String DROP_TABLE_FAVORIS_P = "DROP TABLE IF EXISTS "+TABLE_FAVORIS_P+";";

    //===============================Table association Favoris enseigne=================================//
    public static final String TABLE_FAVORIS_E="FavorisE";
    public static final String COL_LOGIN_PERSONNE_FE="login_personne";
    public static final String COL_LOGIN_FAVORIS_E="login_favoris_e";

    //Creation table assoc
    private static final String CREATE_TABLE_FAVORIS_E = "CREATE TABLE IF NOT EXISTS "+ TABLE_FAVORIS_E+
            "("+COL_LOGIN_PERSONNE_FE+" TEXT NOT NULL," +
            COL_LOGIN_FAVORIS_E +" TEXT NOT NULL," +
            "FOREIGN KEY ("+COL_LOGIN_PERSONNE_FE+") REFERENCES "+TABLE_PERSONNE+"("+COL_LOGIN_PERSONNE+")," +
            "FOREIGN KEY ("+COL_LOGIN_FAVORIS_E+") REFERENCES "+TABLE_ENSEIGNE+"("+COL_LOGIN_ENSEIGNE+"));";

    //Suppression table assoc
    private static final String DROP_TABLE_FAVORIS_E = "DROP TABLE IF EXISTS "+TABLE_FAVORIS_E+";";

    //=======================================Table Evenement=====================================//
    public static final String TABLE_EVENEMENT="Evenement";
    public static final String COL_ID_EVENEMENT= "id_evenement";
    public static final String COL_INTITULE= "intitule";
    public static final String COL_DESCRIPTION_EV = "description_e";
    public static final String COL_DATE_DEBUT = "date_debut";
    public static final String COL_DATE_FIN = "date_fin";
    public static final String COL_H_DEBUT = "h_debut_evenement";
    public static final String COL_H_FIN = "h_fin_evenement";
    public static final String COL_LOGIN_P_E = "login_personne";

    //Creation table Evenement
    private static final String CREATE_TABLE_EVENEMENT = "CREATE TABLE IF NOT EXISTS "+ TABLE_EVENEMENT +
            "("+COL_ID_EVENEMENT+" INTEGER PRIMARY KEY AUTOINCREMENT," + COL_INTITULE +" TEXT,"+
            COL_DESCRIPTION_EV +" TEXT ,"+COL_DATE_DEBUT +" TEXT,"+COL_DATE_FIN +" TEXT,"
            +COL_H_DEBUT +" TEXT,"+COL_H_FIN +" TEXT,"+COL_LOGIN_P_E +" TEXT NOT NULL," +
            "FOREIGN KEY ("+COL_LOGIN_P_E+") REFERENCES "+TABLE_FAVORIS_P+"("+COL_LOGIN_FAVORIS_F+"));";

    //Suppression table Evenement
    private static final String DROP_TABLE_EVENEMENT = "DROP TABLE IF EXISTS "+TABLE_EVENEMENT+";";

    //==============================================Table Invités===============================//
    public static final String TABLE_INVITE="inviteevenement";
    public static final String COL_LOGIN_FAVORIS_INVITE = "login_favoris_p";
    public static final String COL_ID_EVENEMENT_INVIT = "id_evenement";

    //Creation table Invité
    private static final String CREATE_TABLE_INVITE = "CREATE TABLE IF NOT EXISTS "+ TABLE_INVITE +
            "("+COL_LOGIN_FAVORIS_INVITE +" TEXT NOT NULL,"+ COL_ID_EVENEMENT_INVIT +" TEXT NOT NULL," +
            "FOREIGN KEY ("+COL_LOGIN_FAVORIS_INVITE+") REFERENCES "+TABLE_FAVORIS_P+"("+COL_LOGIN_PERSONNE_F+")"+
            "FOREIGN KEY ("+COL_ID_EVENEMENT_INVIT+") REFERENCES "+TABLE_EVENEMENT+"("+COL_ID_EVENEMENT+"));";

    //Suppression table Invité
    private static final String DROP_TABLE_INVITE = "DROP TABLE IF EXISTS "+TABLE_INVITE+";";

    //=================================== insertion de quelques données ====================================//
    //Bures
    private static final String INSERT_LOC2="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  ('2' , '48.699373' , '2.171295');";
    private static final String INSERT_LOC3="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  ('3' , '48.859407' , '2.349344');";
    private static final String INSERT_LOC4="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  ('4' , '48.693375' , '2.15776');";
    //Naterre
    private static final String INSERT_LOC5="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  ('5' , '48.8993' , '2.209665');";
    private static final String INSERT_LOC1="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  ('1' , '48.905013','2.214943');";
    private static final String INSERT_LOC6="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES ('6','48.840193' , '2.349829');";

    private static final String INSERT_PERSONNE1="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  ('nacer' , '12345', '1' , 'nacer');";
    private static final String INSERT_PERSONNE2="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  ('cedric' , '12345', '2' , 'cedric');";
    private static final String INSERT_PERSONNE3="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  ('andrea' , '12345', '3' , 'andrea');";

    private static final String INSERT_ENSEIGNE1="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  ('bistro' , '12345' , 'Bistrot Romain', \"Un bistrot traditionnel, le personnel parle aussi bien anglais que\'espagnol\", '4');";
    private static final String INSERT_ENSEIGNE2="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  ('ramoneur' , '12345' , 'Le ramoneur de paris' , \"Ramoneur de père en fils je connais la ville comme ma poche, besoin d\'aide?\", '5');";
    private static final String INSERT_ENSEIGNE3="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  ('macDo' , '12345' , 'Macdo' , 'Vive le macdo', '6');";

    private static final String INSERT_LANGUE1="INSERT INTO "+TABLE_LANGUE+"("+COL_ID_LANGUE+","+COL_NOM_LANGUE+") VALUES  ('1','French');";
    private static final String INSERT_LANGUE2="INSERT INTO "+TABLE_LANGUE+"("+COL_ID_LANGUE+","+COL_NOM_LANGUE+") VALUES  ('2','English');";
    private static final String INSERT_LANGUE3="INSERT INTO "+TABLE_LANGUE+"("+COL_ID_LANGUE+","+COL_NOM_LANGUE+") VALUES  ('3','Spanish');";
    private static final String INSERT_LANGUE4="INSERT INTO "+TABLE_LANGUE+"("+COL_ID_LANGUE+","+COL_NOM_LANGUE+") VALUES  ('4','Dutsh');";
    private static final String INSERT_LANGUE5="INSERT INTO "+TABLE_LANGUE+"("+COL_ID_LANGUE+","+COL_NOM_LANGUE+") VALUES  ('5','Italian');";
    private static final String INSERT_LANGUE6="INSERT INTO "+TABLE_LANGUE+"("+COL_ID_LANGUE+","+COL_NOM_LANGUE+") VALUES  ('6','Chinese');";
    private static final String INSERT_LANGUE7="INSERT INTO "+TABLE_LANGUE+"("+COL_ID_LANGUE+","+COL_NOM_LANGUE+") VALUES  ('7','Japanese');";

    private static final String INSERT_LANGUE_ENSEIGNE1="INSERT INTO "+TABLE_LANGUE_ENSEIGNE+"("+COL_LOGIN_ENSEIGNE_LE+" , "+COL_ID_LANGUE_LE+") VALUES  ('bistro','1');";
    private static final String INSERT_LANGUE_ENSEIGNE2="INSERT INTO "+TABLE_LANGUE_ENSEIGNE+"("+COL_LOGIN_ENSEIGNE_LE+" , "+COL_ID_LANGUE_LE+") VALUES  ('ramoneur','2');";
    private static final String INSERT_LANGUE_ENSEIGNE3="INSERT INTO "+TABLE_LANGUE_ENSEIGNE+"("+COL_LOGIN_ENSEIGNE_LE+" , "+COL_ID_LANGUE_LE+") VALUES  ('macDo','3');";

    private static final String INSERT_LANGUE_PERSONNE1="INSERT INTO "+TABLE_LANGUE_PERSONNE+"("+COL_LOGIN_PERSONNE_LP+" , "+COL_ID_LANGUE_LU+") VALUES  ('nacer','1');";
    private static final String INSERT_LANGUE_PERSONNE2="INSERT INTO "+TABLE_LANGUE_PERSONNE+"("+COL_LOGIN_PERSONNE_LP+" , "+COL_ID_LANGUE_LU+") VALUES  ('cedric','2');";
    private static final String INSERT_LANGUE_PERSONNE3="INSERT INTO "+TABLE_LANGUE_PERSONNE+"("+COL_LOGIN_PERSONNE_LP+" , "+COL_ID_LANGUE_LU+") VALUES  ('cedric','3');";
    private static final String INSERT_LANGUE_PERSONNE4="INSERT INTO "+TABLE_LANGUE_PERSONNE+"("+COL_LOGIN_PERSONNE_LP+" , "+COL_ID_LANGUE_LU+") VALUES  ('andrea','3');";

    private static final String INSERT_MESSAGE1="INSERT INTO "+TABLE_MESSAGE+"("+COL_ID_MESSAGE+" , "+COL_OBJET_MESSAGE+" , "+COL_MESSAGE+", "+COL_DATE_MESSAGE+", "+COL_LOGIN_EMETTEUR+" , "+COL_LOGIN_RECEPTEUR+")" +
            " VALUES  ('1','Bonjour','Bonjour je suis perdu peux tu me venir en aide?','2013-11-29', 'andrea', 'cedric');";
    private static final String INSERT_MESSAGE2="INSERT INTO "+TABLE_MESSAGE+"("+COL_ID_MESSAGE+" , "+COL_OBJET_MESSAGE+" , "+COL_MESSAGE+", "+COL_DATE_MESSAGE+", "+COL_LOGIN_EMETTEUR+" , "+COL_LOGIN_RECEPTEUR+")" +
            " VALUES  ('2','Bonjour','Ok je vais faire comme ça','2013-11-29', 'andrea', 'cedric');";
    private static final String INSERT_MESSAGE3="INSERT INTO "+TABLE_MESSAGE+"("+COL_ID_MESSAGE+" , "+COL_OBJET_MESSAGE+" , "+COL_MESSAGE+", "+COL_DATE_MESSAGE+", "+COL_LOGIN_EMETTEUR+" , "+COL_LOGIN_RECEPTEUR+")" +
            " VALUES  ('3','Bonjour','Bonjour, va la bas','2013-11-29', 'cedric', 'andrea');";
    private static final String INSERT_MESSAGE4="INSERT INTO "+TABLE_MESSAGE+"("+COL_ID_MESSAGE+" , "+COL_OBJET_MESSAGE+" , "+COL_MESSAGE+", "+COL_DATE_MESSAGE+", "+COL_LOGIN_EMETTEUR+" , "+COL_LOGIN_RECEPTEUR+")" +
            " VALUES  ('4','Bonjour',\"Merci j\'ai trouvé !!\",'2013-11-29', 'andrea', 'cedric');";
    private static final String INSERT_MESSAGE5="INSERT INTO "+TABLE_MESSAGE+"("+COL_ID_MESSAGE+" , "+COL_OBJET_MESSAGE+" , "+COL_MESSAGE+", "+COL_DATE_MESSAGE+", "+COL_LOGIN_EMETTEUR+" , "+COL_LOGIN_RECEPTEUR+")" +
            " VALUES  ('5','Yo','Je te vois !','2013-11-29', 'nacer', 'cedric');";
    private static final String INSERT_MESSAGE6="INSERT INTO "+TABLE_MESSAGE+"("+COL_ID_MESSAGE+" , "+COL_OBJET_MESSAGE+" , "+COL_MESSAGE+", "+COL_DATE_MESSAGE+", "+COL_LOGIN_EMETTEUR+" , "+COL_LOGIN_RECEPTEUR+")" +
            " VALUES  ('6','hey','Bonjour moi !','2013-11-29', 'cedric', 'cedric');";





    //insertion localisation personnes

    private static final String INSERT_LOC7="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"7\" , \"48.904928\" , \"2.216059\");";
    private static final String INSERT_LOC8="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"8\" , \"48.896662\" , \"2.244129\");";
    private static final String INSERT_LOC9="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"9\" , \"48.879506\" , \"2.299377\");";
    private static final String INSERT_LOC10="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"10\" , \"48.875329\" , \"2.289249\");";
    private static final String INSERT_LOC11="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"11\" , \"48.860198\" , \"2.299549\");";
    private static final String INSERT_LOC12="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"12\" , \"48.844158\" , \"2.284786\");";
    private static final String INSERT_LOC13="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"13\" , \"48.870699\" , \"2.31414\");";
    private static final String INSERT_LOC14="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"14\" , \"48.854889\" , \"2.347957\");";
    private static final String INSERT_LOC15="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"15\" , \"48.836814\" , \"2.343494\");";
    private static final String INSERT_LOC16="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"16\" , \"48.81975\" , \"2.314999\");";
    private static final String INSERT_LOC17="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"17\" , \"48.863924\" , \"2.36478\");";
    private static final String INSERT_LOC18="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"18\" , \"48.88436\" , \"2.383148\");";
    private static final String INSERT_LOC19="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"19\" , \"48.851388\" , \"2.394478\");";
    private static final String INSERT_LOC20="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"20\" , \"48.845288\" , \"2.288734\");";
    private static final String INSERT_LOC21="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"21\" , \"48.866522\" , \"2.286133\");";
    private static final String INSERT_LOC22="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"22\" , \"48.822463\" , \"2.25695\");";
    private static final String INSERT_LOC23="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"23\" , \"48.862908\" , \"2.24871\");";
    private static final String INSERT_LOC24="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"24\" , \"48.884586\" , \"2.194465\");";
    private static final String INSERT_LOC25="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"25\" , \"48.907044\" , \"2.19957\");";
    private static final String INSERT_LOC26="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"26\" , \"48.907326\" , \"2.2218\");";
    private static final String INSERT_LOC27="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"27\" , \"48.903433\" , \"2.216993\");";
    private static final String INSERT_LOC28="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"28\" , \"48.902023\" , \"2.212444\");";
    private static final String INSERT_LOC29="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"29\" , \"48.854889\" , \"2.348957\");";
    private static final String INSERT_LOC30="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"30\" , \"48.866522\" , \"2.287133\");";

    //insertion localisation ENSEIGNE
    private static final String INSERT_LOC31="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"31\" , \"48.88896\" , \"2.249297\");";
    private static final String INSERT_LOC32="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"32\" , \"48.885715\" , \"2.319633\");";
    private static final String INSERT_LOC33="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"33\" , \"48.858278\" , \"2.332165\");";
    private static final String INSERT_LOC34="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"34\" , \"48.879957\" , \"2.386238\");";
    private static final String INSERT_LOC35="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"35\" , \"48.851049\" , \"2.393448\");";
    private static final String INSERT_LOC36="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"36\" , \"48.891295\" , \"2.235609\");";
    private static final String INSERT_LOC37="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"37\" , \"48.877925\" , \"2.409241\");";
    private static final String INSERT_LOC38="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"38\" , \"48.849129\" , \"2.381775\");";
    private static final String INSERT_LOC39="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"39\" , \"48.828566\" , \"2.359115\");";
    private static final String INSERT_LOC40="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"40\" , \"48.881651\" , \"2.170631\");";
    private static final String INSERT_LOC41="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"41\" , \"48.892466\" , \"2.239106\");";
    private static final String INSERT_LOC42="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"42\" , \"48.886166\" , \"2.179558\");";
    private static final String INSERT_LOC43="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"43\" , \"48.886166\" , \"2.166511\");";
    private static final String INSERT_LOC44="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"44\" , \"48.918777\" , \"2.250282\");";
    private static final String INSERT_LOC45="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"45\" , \"48.846756\" , \"2.348314\");";
    private static final String INSERT_LOC46="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"46\" , \"48.922725\" , \"2.339031\");";
    private static final String INSERT_LOC47="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"47\" , \"48.889665\" , \"2.381088\");";
    private static final String INSERT_LOC48="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"48\" , \"48.858729\" , \"2.380058\");";
    private static final String INSERT_LOC49="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"49\" , \"48.8576\" , \"2.356026\");";
    private static final String INSERT_LOC50="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"50\" , \"48.822562\" , \"2.334205\");";
    private static final String INSERT_LOC51="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"51\" , \"48.907044\" , \"2.337658\");";
    private static final String INSERT_LOC52="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"52\" , \"48.890582\" , \"2.238398\");";
    private static final String INSERT_LOC53="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"53\" , \"48.820132\" , \"2.338647\");";
    private static final String INSERT_LOC54="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"54\" , \"48.839441\" , \"2.333\");";
    private static final String INSERT_LOC55="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"55\" , \"48.822562\" , \"2.334205\");";
    private static final String INSERT_LOC56="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"56\" , \"48.892987\" , \"2.242432\");";
    private static final String INSERT_LOC57="INSERT INTO "+TABLE_LOCALISATION+"("+COL_ID_LOC+","+COL_LATITUDE+","+COL_LONGITUDE+") VALUES  (\"57\" , \"48.830967\" , \"2.315319\");";

    //insertion personnes
    private static final String INSERT_PERSONNE5="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"claire\" , \"12345\", \"5\" , \"claire\");";
    private static final String INSERT_PERSONNE6="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"jackson\" , \"12345\", \"6\" , \"jackson\");";
    private static final String INSERT_PERSONNE7="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"maxime\" , \"12345\", \"7\" , \"maxime\");";
    private static final String INSERT_PERSONNE8="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"thomas\" , \"12345\", \"8\" , \"thomas\");";
    private static final String INSERT_PERSONNE9="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"philippe\" , \"12345\", \"9\" , \"philippe\");";
    private static final String INSERT_PERSONNE10="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"julien\" , \"12345\", \"10\" , \"julien\");";
    private static final String INSERT_PERSONNE11="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"jude\" , \"12345\", \"11\" , \"jude\");";
    private static final String INSERT_PERSONNE12="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"elise\" , \"12345\", \"12\" , \"elise\");";
    private static final String INSERT_PERSONNE13="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"diandra\" , \"12345\", \"13\" , \"diandra\");";
    private static final String INSERT_PERSONNE14="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"moussa\" , \"12345\", \"14\" , \"moussa\");";
    private static final String INSERT_PERSONNE15="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"mai\" , \"12345\", \"15\" , \"mai\");";
    private static final String INSERT_PERSONNE16="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"lan\" , \"12345\", \"16\" , \"lan\");";
    private static final String INSERT_PERSONNE17="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"brahim\" , \"12345\", \"17\" , \"brahim\");";
    private static final String INSERT_PERSONNE18="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"karima\" , \"12345\", \"18\" , \"karima\");";
    private static final String INSERT_PERSONNE19="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"kabine\" , \"12345\", \"19\" , \"kabine\");";
    private static final String INSERT_PERSONNE20="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"nicole\" , \"12345\", \"20\" , \"nicole\");";
    private static final String INSERT_PERSONNE21="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"momar\" , \"12345\", \"21\" , \"momar\");";
    private static final String INSERT_PERSONNE22="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"akouiass\" , \"12345\", \"22\" , \"akouiass\");";
    private static final String INSERT_PERSONNE23="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"john\" , \"12345\", \"23\" , \"john\");";
    private static final String INSERT_PERSONNE24="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"pedro\" , \"12345\", \"24\" , \"pedro\");";
    private static final String INSERT_PERSONNE25="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"beatriz\" , \"12345\", \"25\" , \"beatriz\");";
    private static final String INSERT_PERSONNE26="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"paula\" , \"12345\", \"26\" , \"paula\");";
    private static final String INSERT_PERSONNE27="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"ceci\" , \"12345\", \"27\" , \"ceci\");";
    private static final String INSERT_PERSONNE28="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"frantz\" , \"12345\", \"28\" , \"frantz\");";
    private static final String INSERT_PERSONNE29="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"lee\" , \"12345\", \"29\" , \"lee\");";
    private static final String INSERT_PERSONNE30="INSERT INTO "+TABLE_PERSONNE+" ("+COL_LOGIN_PERSONNE+","+COL_PWD_PERSONNE+","+COL_ID_LOC_P+","+COL_PSEUDO+") VALUES  (\"eric\" , \"12345\", \"30\" , \"eric\");";

    //insertion ENSEIGNE
    private static final String INSERT_ENSEIGNE5= "INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"kirane\" , \"12345\" , \" Kirane's et Nirvana‎\", \"Restaurant indien\", \"31\");";
    private static final String INSERT_ENSEIGNE6= "INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"idees\" , \"12345\" , \"Les Idées Restos\", \"Restaurant Etrangers\", \"32\");";
    private static final String INSERT_ENSEIGNE7= "INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"krishna\" , \"12345\" , \"Krishna-bhavan \",\" spécialités indiennes et végétariennes\", \"33\");";
    private static final String INSERT_ENSEIGNE8= "INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"yasube\" , \"12345\" , \"Yasube\", \"Restaurant japonais\", \"34\");";
    private static final String INSERT_ENSEIGNE9= "INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"anahuacalli\" , \"12345\" , \"Anahuacalli\", \"Manger mexicain\", \"35\");";
    private static final String INSERT_ENSEIGNE10="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"porta\" , \"12345\" , \"Restaurant Porta da Selva\", \"Restaurant Bresilien\", \"36\");";
    private static final String INSERT_ENSEIGNE11="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"toto\" , \"12345\" , \"Ristorante da Totò e Peppino\", \"Gastronomie italienne\", \"37\");";
    private static final String INSERT_ENSEIGNE12="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"gioia\" , \"12345\" , \"Gioia mia\", \"Petit resto italien\", \"38\");";
    private static final String INSERT_ENSEIGNE13="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"mog\" , \"12345\" , \"Mog Mog Japon\", \"Restaurant japonais\", \"39\");";
    private static final String INSERT_ENSEIGNE14="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"pousee\" , \"12345\" , \"Pousse-pousse\", \"Restaurants bio/végétariens\", \"40\");";
    private static final String INSERT_ENSEIGNE15="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"boco\" , \"12345\" , \"Boco : du bio en bocaux\", \"Restaurants bio/végétariens\", \"41\");";
    private static final String INSERT_ENSEIGNE16="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"fogon\" , \"12345\" , \"El fogón de san Julián\", \"Cuisine espagnole \", \"42\");";
    private static final String INSERT_ENSEIGNE17="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"menkes\",\"12345\",\"Menkes\",\"Flamenko\",\"43\");";
    private static final String INSERT_ENSEIGNE18="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"thanksgivin\" , \"12345\", \"Thanksgiving\", \"Resto Américain\", \"44\");";
    private static final String INSERT_ENSEIGNE19="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"mikhail\" , \"12345\", \"Mikhaïl Rudy\", \"Librairie russe\", \"45\");";
    private static final String INSERT_ENSEIGNE20="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"kazuko\" , \"12345\", \"Kazuko Masui\",\"Gastronomie Japonaise \", \"46\");";
    private static final String INSERT_ENSEIGNE21="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"hobo\" , \"12345\", \"Hobo\",\" Musique  Anglaise\", \"47\");";
    private static final String INSERT_ENSEIGNE22="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"memories\" ,\"12345\",\"Mémoires de porc-épic\",\"Galerie Congolaise\",\"48\");";
    private static final String INSERT_ENSEIGNE23="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"peter\" ,\"12345\",\"Peter von Poehl\",\"Musicien suédoise\", \"49\");";
    private static final String INSERT_ENSEIGNE24="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"canelas\" ,\"12345\",\"Canelas\",\"Concert portugais\",\"50\");";
    private static final String INSERT_ENSEIGNE25="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"comptoir\" ,\"12345\",\"Comptoir de Tunisie\",\"Magasin\",\"51\");";
    private static final String INSERT_ENSEIGNE26="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"junku\",\"12345\",\"JUNKU\",\"Librairie Japonaise\",\"52\");";
    private static final String INSERT_ENSEIGNE27="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"cite\",\"12345\",\"Cité Internationale Universitaire\",\"Maison Internationale \",\"53\");";
    private static final String INSERT_ENSEIGNE28="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"paulo\",\"12345\",\"Dr. Paulo Da Silva Moreira\",\"Docteur Portugais\",\"54\");";
    private static final String INSERT_ENSEIGNE29="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"desmos\" ,\"12345\",\"Desmos\",\"Librairie Grecque\",\"55\");";
    private static final String INSERT_ENSEIGNE30="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"jeanpierre\",\"12345\",\"Docteur Jean Pierre Viltart\",\"Docteur Espagnol\",\"56\");";
    private static final String INSERT_ENSEIGNE31="INSERT INTO "+TABLE_ENSEIGNE+" ("+COL_LOGIN_ENSEIGNE+","+COL_PWD_Enseigne+","+COL_NOM_ENSEIGNE+","+COL_DESC_ENSEIGNE+","+COL_ID_LOC_E+") VALUES  (\"babel\",\"12345\",\"Tour de Babel\",\"Librairie italienne\",\"57\");";


    public BdLocatme(Context context) {
        super(context,NOM_BDD, null,VERSION_BDD);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //To change body of implemented methods use File | Settings | File Templates.
        db.execSQL(CREATE_TABLE_TYPE_ETAB);
        db.execSQL(CREATE_TABLE_LOCALISATION);
        db.execSQL(CREATE_TABLE_NOTE);
        db.execSQL(CREATE_TABLE_ENSEIGNE);
        db.execSQL(CREATE_TABLE_PERSONNE);
        db.execSQL(CREATE_TABLE_COMMENTAIRE);
        db.execSQL(CREATE_TABLE_MESSAGE);
        db.execSQL(CREATE_TABLE_LANGUE);
        db.execSQL(CREATE_TABLE_LANGUE_ENSEIGNE);
        db.execSQL(CREATE_TABLE_LANGUE_PERSONNE);
        db.execSQL(CREATE_TABLE_FAVORIS_P);
        db.execSQL(CREATE_TABLE_FAVORIS_E);
        db.execSQL(INSERT_PERSONNE1);
        db.execSQL(INSERT_PERSONNE2);
        db.execSQL(INSERT_PERSONNE3);
        db.execSQL(INSERT_LANGUE1);
        db.execSQL(INSERT_LANGUE2);
        db.execSQL(INSERT_LANGUE3);
        db.execSQL(INSERT_LANGUE4);
        db.execSQL(INSERT_LANGUE5);
        db.execSQL(INSERT_LANGUE6);
        db.execSQL(INSERT_LANGUE7);
        db.execSQL(INSERT_LANGUE_ENSEIGNE1);
        db.execSQL(INSERT_LANGUE_ENSEIGNE2);
        db.execSQL(INSERT_LANGUE_ENSEIGNE3);
        db.execSQL(INSERT_LANGUE_PERSONNE1);
        db.execSQL(INSERT_LANGUE_PERSONNE2);
        db.execSQL(INSERT_LANGUE_PERSONNE3);
        db.execSQL(INSERT_LANGUE_PERSONNE4);


        db.execSQL(INSERT_LOC1);
        db.execSQL(INSERT_LOC2);
        db.execSQL(INSERT_LOC3);
        db.execSQL(INSERT_LOC4);
        db.execSQL(INSERT_LOC5);
        db.execSQL(INSERT_LOC6);
        db.execSQL(INSERT_LOC7);
        db.execSQL(INSERT_LOC8);
        db.execSQL(INSERT_LOC9);
        db.execSQL(INSERT_LOC10);
        db.execSQL(INSERT_LOC11);
        db.execSQL(INSERT_LOC12);
        db.execSQL(INSERT_LOC13);
        db.execSQL(INSERT_LOC14);
        db.execSQL(INSERT_LOC15);
        db.execSQL(INSERT_LOC16);
        db.execSQL(INSERT_LOC17);
        db.execSQL(INSERT_LOC18);
        db.execSQL(INSERT_LOC19);
        db.execSQL(INSERT_LOC20);
        db.execSQL(INSERT_LOC21);
        db.execSQL(INSERT_LOC22);
        db.execSQL(INSERT_LOC23);
        db.execSQL(INSERT_LOC24);
        db.execSQL(INSERT_LOC25);
        db.execSQL(INSERT_LOC26);
        db.execSQL(INSERT_LOC27);
        db.execSQL(INSERT_LOC28);
        db.execSQL(INSERT_LOC29);
        db.execSQL(INSERT_LOC30);
        db.execSQL(INSERT_PERSONNE5);
        db.execSQL(INSERT_PERSONNE6);
        db.execSQL(INSERT_PERSONNE7);
        db.execSQL(INSERT_PERSONNE8);
        db.execSQL(INSERT_PERSONNE9);
        db.execSQL(INSERT_PERSONNE10);
        db.execSQL(INSERT_PERSONNE11);
        db.execSQL(INSERT_PERSONNE12);
        db.execSQL(INSERT_PERSONNE13);
        db.execSQL(INSERT_PERSONNE14);
        db.execSQL(INSERT_PERSONNE15);
        db.execSQL(INSERT_PERSONNE16);
        db.execSQL(INSERT_PERSONNE17);
        db.execSQL(INSERT_PERSONNE18);
        db.execSQL(INSERT_PERSONNE19);
        db.execSQL(INSERT_PERSONNE20);
        db.execSQL(INSERT_PERSONNE21);
        db.execSQL(INSERT_PERSONNE22);
        db.execSQL(INSERT_PERSONNE23);
        db.execSQL(INSERT_PERSONNE24);
        db.execSQL(INSERT_PERSONNE25);
        db.execSQL(INSERT_PERSONNE26);
        db.execSQL(INSERT_PERSONNE27);
        db.execSQL(INSERT_PERSONNE28);
        db.execSQL(INSERT_PERSONNE29);
        db.execSQL(INSERT_PERSONNE30);
        db.execSQL(INSERT_LOC31);
        db.execSQL(INSERT_LOC32);
        db.execSQL(INSERT_LOC33);
        db.execSQL(INSERT_LOC34);
        db.execSQL(INSERT_LOC35);
        db.execSQL(INSERT_LOC36);
        db.execSQL(INSERT_LOC37);
        db.execSQL(INSERT_LOC38);
        db.execSQL(INSERT_LOC39);
        db.execSQL(INSERT_LOC40);
        db.execSQL(INSERT_LOC41);
        db.execSQL(INSERT_LOC42);
        db.execSQL(INSERT_LOC43);
        db.execSQL(INSERT_LOC44);
        db.execSQL(INSERT_LOC45);
        db.execSQL(INSERT_LOC46);
        db.execSQL(INSERT_LOC47);
        db.execSQL(INSERT_LOC48);
        db.execSQL(INSERT_LOC49);
        db.execSQL(INSERT_LOC50);
        db.execSQL(INSERT_LOC51);
        db.execSQL(INSERT_LOC52);
        db.execSQL(INSERT_LOC53);
        db.execSQL(INSERT_LOC54);
        db.execSQL(INSERT_LOC55);
        db.execSQL(INSERT_LOC56);
        db.execSQL(INSERT_LOC57);
        db.execSQL(INSERT_ENSEIGNE1);
        db.execSQL(INSERT_ENSEIGNE2);
        db.execSQL(INSERT_ENSEIGNE5);
        db.execSQL(INSERT_ENSEIGNE6);
        db.execSQL(INSERT_ENSEIGNE7);
        db.execSQL(INSERT_ENSEIGNE8);
        db.execSQL(INSERT_ENSEIGNE9);
        db.execSQL(INSERT_ENSEIGNE10);
        db.execSQL(INSERT_ENSEIGNE11);
        db.execSQL(INSERT_ENSEIGNE12);
        db.execSQL(INSERT_ENSEIGNE13);
        db.execSQL(INSERT_ENSEIGNE14);
        db.execSQL(INSERT_ENSEIGNE15);
        db.execSQL(INSERT_ENSEIGNE16);
        db.execSQL(INSERT_ENSEIGNE17);
        db.execSQL(INSERT_ENSEIGNE18);
        db.execSQL(INSERT_ENSEIGNE19);
        db.execSQL(INSERT_ENSEIGNE20);
        db.execSQL(INSERT_ENSEIGNE21);
        db.execSQL(INSERT_ENSEIGNE22);
        db.execSQL(INSERT_ENSEIGNE23);
        db.execSQL(INSERT_ENSEIGNE24);
        db.execSQL(INSERT_ENSEIGNE25);
        db.execSQL(INSERT_ENSEIGNE26);
        db.execSQL(INSERT_ENSEIGNE27);
        db.execSQL(INSERT_ENSEIGNE28);
        db.execSQL(INSERT_ENSEIGNE29);
        db.execSQL(INSERT_ENSEIGNE30);
        db.execSQL(INSERT_ENSEIGNE31);
        db.execSQL(INSERT_MESSAGE1);
        db.execSQL(INSERT_MESSAGE2);
        db.execSQL(INSERT_MESSAGE3);
        db.execSQL(INSERT_MESSAGE4);
        db.execSQL(INSERT_MESSAGE5);
        db.execSQL(INSERT_MESSAGE6);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL(DROP_TABLE_ENSEIGNE);
        db.execSQL(DROP_TABLE_PERSONNE);
        db.execSQL(DROP_TABLE_LOCALISATION);
        db.execSQL(DROP_TABLE_COMMENTAIRE);
        db.execSQL(DROP_TABLE_MESSAGE);
        db.execSQL(DROP_TABLE_NOTE);
        db.execSQL(DROP_TABLE_LANGUE);
        db.execSQL(DROP_TABLE_TYPE_ETAB);
        db.execSQL(DROP_TABLE_FAVORIS_E);
        db.execSQL(DROP_TABLE_FAVORIS_P);
        db.execSQL(DROP_TABLE_LANGUE_ENSEIGNE);
        db.execSQL(DROP_TABLE_LANGUE_PERSONNE);
        onCreate(db);
        //To change body of implemented methods use File | Settings | File Templates.
    }

}
